package w83a.w83aDAO.w83aConstantesBD;

public class W83aPreavisosBD {
	
	public static String maxNumPreaviso = "999999";

	public static String preavisosTable = "W83B37S00";
	public static String preavisos_originalesTable = "W83B53S00";
	public static String preavisos_sindicatos_table = "W83B27S00";
	public static String preavisos_docsTable = "W83B38S00";
	public static String preavisosOriginalesView = "W83B02V00";
	public static String preaviso_historial_Synonym = "W83B55S00";
	public static String historial_tramitacion_Synonym = "W83B56S00";
	public static String vista_historial_tramitacion = "W83BHIST_TRAMITACION_PREAVISOS";
	
	public static String preavisos_docsView = "W83BDOCSPREAVISOS";
	
	public static String n_preaviso_056 = "N_PREAVISO_056";
	public static String ano_preaviso_056 = "ANO_PREAVISO_056";
	public static String c_territ_056 = "C_TERRIT_056";
	public static String c_tram_056 = "C_TRAM_056";
	public static String c_fase_056 = "C_FASE_056";
	public static String f_actu_056 = "F_ACTU_056";
	public static String usua_056 = "USUA_056";
	public static String usu_mod_056 = "USU_MOD_056";
	public static String f_modif_056 = "F_MODIF_056";
	public static String f_tram_056 = "F_TRAM_056";
	public static String f_reg_sal_056 = "F_REG_SAL_056";
	public static String n_reg_sal_056 = "N_REG_SAL_056";

	public static String descripcion = "DESCRIPCION";
	
	public static String preaviso_original_sindicatos_table = "W83B54T00";
	public static String preaviso_impugnaciones_View= "W83BIMPUGNACIONES";
	
	public static String codcentro = "CODCENTRO";
	public static String id_centrotrabajo = "ID_CENTROTRABAJO";
	public static String num_impugnacion = "NUM_IMPUGNACION";
	public static String num_impugnacion_completo = "NUM_IMPUGNACION_COMPLETO";
	public static String fech_impugnacion = "FECH_IMPUGNACION";
	public static String desc_sindicatos = "DESC_SINDICATOS";
	public static String dese_sindicatos = "DESE_SINDICATOS";
	public static String dni_arbitro = "DNI_ARBITRO";
	public static String nombre_arbitro = "NOMBRE_ARBITRO";
	public static String num_laudo = "NUM_LAUDO";
	public static String num_laudocompleto = "NUM_LAUDOCOMPLETO";
	public static String num_laudocompletoint = "NUM_LAUDOCOMPLETOINT";
	public static String fech_laudo = "FECH_LAUDO";
	public static String fech_envio_juzgado = "FECH_ENVIO_JUZGADO";
	public static String fech_sentencia = "FECH_SENTENCIA";
	public static String fech_baja_desestimiento = "FECH_BAJA_DESESTIMIENTO";
	public static String numeroImpugnaciones = "NUMEROIMPUGNACIONES";
	public static String dirAlternativa = "DIRALTERNATIVA";
	public static String codPostalalternativa = "CODPOSTALALTERNATIVA";
	public static String idProvincia_alt = "IDPROVINCIA_ALT";
	public static String codMunicipio_alt = "CODMUNICIPIO_ALT";
	public static String cod_territorio_centro = "COD_TERRITORIO_CENTRO";
	public static String codPostal = "COD_POSTAL";
	public static String domicilio = "DOMICILIO";
	public static String localidad = "LOCALIDAD";
	public static String resultado = "RESULTADO";
	public static String desc_tipo = "DESC_TIPO";
	public static String dese_tipo = "DESE_TIPO";
	public static String nombreImpugnante = "NOMBREIMPUGNANTE";
	public static String rdto_cas = "RDTO_CAS";
	public static String rdto_eus = "RDTO_EUS";
	public static String telefono = "TELEFONO";
	public static String fax = "FAX";
	public static String email = "EMAIL";
	public static String territsegsocialv02 = "TERRITSEGSOCIAL";
	public static String numsegsocialv02  = "NUMSEGSOCIAL";
	public static String digitcontsegsocial = "DIGITCONTSEGSOCIAL";
	public static String numtrabv02  = "NUMTRAB";
	public static String numRegistroES = "N_REGIS";
	public static String fechaRegistroES  = "F_REGIS";
	
	
	public static String tipoPreaviso = "tipopreaviso";
		
	public static String nomb_docu_038 = "NOMB_DOCU_038";
	public static String long_docu_038 = "LONG_DOCU_038";
	public static String docu_038 = "DOCUMENTO_038";
	public static String tp_doc_038 = "TP_DOC_038";
	public static String num_reg_038 = "NUM_REG_038";
	public static String f_reg_038 = "F_REG_038";
	public static String usuario_038 = "USUARIO_038";
	public static String id_docu_038 = "ID_DOC_038";
	
	public static String c_tram_038 = "C_TRAM_038";
	public static String c_fase_038 = "C_FASE_038";

	public static String ano_preaviso_055 = "ANO_PREAVISO_055";
	public static String n_preaviso_055 = "N_PREAVISO_055";
	public static String c_territ_055 = "C_TERRIT_055";
	
	public static String ano_preaviso_038 = "ANO_PREAVISO_038";
	public static String n_preaviso_038 = "N_PREAVISO_038";
	public static String c_territ_038 = "C_TERRIT_038";
	
	public static String ano_preaviso_027 = "ANO_PREAVISO_027";
	public static String n_preaviso_027 = "N_PREAVISO_027";
	public static String c_territ_027 = "C_TERRIT_027";
	public static String c_sindi_027 = "C_SINDI_027";
	
	public static String ano_preaviso_054 = "ANO_PREAVISO_054";
	public static String n_preaviso_054 = "N_PREAVISO_054";
	public static String c_territ_054 = "C_TERRIT_054";
	public static String c_sindi_054 = "C_SINDI_054";
	
	public static String ano_preaviso_037 = "ANO_PREAVISO_037";
	public static String n_preaviso_037 = "N_PREAVISO_037";
	public static String c_territ_037 = "C_TERRIT_037";
	public static String oid8501_037 = "OID8501_037";
	public static String id_centro_037 = "ID_CENTRO_037";
	public static String id_centro_j7301 = "ID_CENTRO_J7301";
	public static String f_entra_037 = "F_ENTRA_037";
	public static String f_inicio_037 = "F_INICIO_037";
	public static String f_elecc_037 = "F_ELECC_037";
	public static String f_regis_037 = "F_REGIS_037";
	public static String n_regis_037 = "N_REGIS_037";
	public static String ano_acta_037 = "ANO_ACTA_037";
	public static String n_acta_037 = "N_ACTA_037";
	public static String s_parcial_037 = "S_PARCIAL_037";
	public static String global_037 = "GLOBAL_037";
	public static String observ_037 = "OBSERV_037";
	public static String usua_037 = "USUA_037";
	public static String factu_037 = "FACTU_037";
	public static String convacu_037 = "CONVACU_037";
	public static String admonemp_037 = "ADMONEMP_037";
	public static String n_cenafec_037 = "N_CENAFEC_037";
	public static String fenvio_037 = "FENVIO_037";
	public static String usuenv_037 = "USUENV_037";
	public static String ncarprocelec_037 = "NCARPPROCELEC_037";
	public static String c_territ_nora = "C_TERRIT_NORA";
	public static String c_fase_052 = "C_FASE_052";
	public static String c_tram_012 = "C_TRAM_012";
	public static String c_conv_037 = "C_CONV_037";
	public static String dir_alt_037 = "DIR_ALT_037";
	public static String codPos_alt_037 = "CODPOS_ALT_037";
	public static String mun_alt_037 = "MUN_ALT_037";
	public static String prov_alt_037 = "PROV_ALT_037";

	public static String centroTrabajoView = "w83bcentrotrabajo";
	public static String CODCENTRO = "CODCENTRO";
	public static String CIFNIF = "CIFNIF";
	public static String NCENTROTRABAJO = "NCENTROTRABAJO";
	public static String RAZONSOCIAL = "RAZONSOCIAL";
	public static String DOMICILIO = "DOMICILIO";
	public static String MUNICIPIO = "MUNICIPIO";
	public static String TERRITORIO = "TERRITORIO";
	public static String TERRITORIO_EUSK = "TERRITORIO_EUSK";
	public static String CODTERRITORIO = "CODTERRITORIO";
	public static String CODMUNICIPIO = "CODMUNICIPIO";
	public static String CODPOSTAL = "CODPOSTAL";
	public static String CNAE = "CNAE";
	public static String DESCCNAE = "DESCCNAE";
	public static String NUM_TRABAJADORES = "NUM_TRABAJADORES";	
	
	public static String preavisosView = "W83B01V00";
	public static String preavisosSinCentroView = "w83b01v00SinCentro";

	public static String anyo_eleccion = "ANYO_ELECCION";
	public static String cod_territorio = "COD_TERRITORIO";
	public static String cod_municipio = "COD_MUNICIPIO";
	public static String num_preaviso = "NUMPREAVISO";	
	public static String numpreavisosencilloentero = "NUMPREAVISOSENCILLOENTERO";	
	public static String npreavisosint = "NPREAVISOSINT";	
	public static String npreavisosintcompleto = "npreavisointcompleto";	
	public static String fecha_entrada = "FECHA_ENTRADA";
	public static String fecha_inicio = "FECHA_INICIO";
	public static String razon_social = "RAZON_SOCIAL";
	public static String cif = "CIF";
	public static String num_centro = "NUM_CENTRO";
	public static String territorio = "TERRITORIO";
	public static String territorio_cas = "TERRITORIO_CAS";
	public static String territorio_eus = "TERRITORIO_EUS";
	public static String municipio_cas = "MUNICIPIO_CAS";
	public static String num_trabajadores = "NUM_TRABAJADORES";
	public static String municipio_eus = "MUNICIPIO_EUS";
	public static String municipio = "MUNICIPIO";
	public static String eleccion_parcial = "ELECCION_PARCIAL";
	public static String preaviso_global = "PREAVISO_GLOBAL";
	public static String cod_convenio = "COD_CONVENIO";
	public static String admon_empresa = "ADMON_EMPRESA";
	public static String num_centros_afectados = "NUMCENTROS_AFECTADOS";
	public static String cods_promotores = "CODS_PROMOTORES";
	public static String desc_promotores = "DESC_PROMOTORES";
	public static String dese_promotores = "DESE_PROMOTORES";
	public static String desc_convenio = "DESC_CONVENIO";
	public static String dese_convenio = "DESE_CONVENIO";
	public static String descripcion_convenio = "DESCRIPCION_CONVENIO";
	
	public static String num_preaviso_completo = "NUMPREAVISO_COMPLETO";
	
	public static String fecha_eleccion = "FECHA_ELECCION";
	public static String num_registro = "NUM_REGISTRO";
	public static String fecha_registro = "FECHA_REGISTRO";
	public static String num_acta = "NUM_ACTA";
	public static String observaciones = "OBSERVACIONES";
	public static String anyo_acta = "ANYO_ACTA";
	public static String coterrit_acta = "COD_TERRITORIO";	
	
	//queda definir esta columna en la vista
	public static String f_actu_tramite = "F_ACTU_TRAMITE";
	public static String f_modif_tramite = "F_MODIF_TRAMITE";
	public static String cod_tramite = "COD_TRAMITE";
	
	public static String c_sindi_019 = "C_SINDI_019";
	public static String ano_preaviso_053 = "ANO_PREAVISO_053";
	public static String n_preaviso_053 = "N_PREAVISO_053";
	public static String f_entra_053 = "F_ENTRA_053";
	public static String f_inicio_053 = "F_INICIO_053";
	public static String f_elecc_053 = "F_ELECC_053";
	public static String ano_acta_053 = "ANO_ACTA_053";
	public static String n_acta_053 = "N_ACTA_053";
	public static String s_parcial_053 = "S_PARCIAL_053";
	public static String global_053 = "GLOBAL_053";
	public static String observ_053 = "OBSERV_053";
	public static String usua_053 = "USUA_053";
	public static String factu_053 = "FACTU_053";
	public static String convacu_053 = "CONVACU_053";
	public static String admonemp_053 = "ADMONEMP_053";
	public static String n_cenafec_053 = "N_CENAFEC_053";
	public static String fenvio_053 = "FENVIO_053";
	public static String usuenv_053 = "USUENV_053";
	public static String ncarprocelec_053 = "NCARPPROCELEC_053";
	public static String c_conv_013 = "C_CONV_013";
	public static String ndf_053 = "NDF_053";
	public static String nop_053 = "NOP_053";
	public static String oid5801 = "OID8501";
	public static String ndf_037 = "NDF_037";
	public static String nop_037 = "NOP_037";
	public static String c_conv_053 = "C_CONV_053";
	public static String oid8501_053 = "OID8501_053";
	public static String c_territ_053 = "C_TERRIT_053";
	public static String id_centro_053 = "ID_CENTRO_053";
	public static String dir_alt_053 = "DIR_ALT_053";
	public static String codPos_alt_053 = "CODPOS_ALT_053";
	public static String mun_alt_053 = "MUN_ALT_053";
	public static String prov_alt_053 = "PROV_ALT_053";
	public static String nif_centro_053 = "NIF_CENTRO_053";
	public static String num_centro_053 = "NUM_CENTRO_053";
	public static String raz_social_053 = "RAZ_SOCIAL_053";	
	
	public static String factu_055 = "FACTU_055";
	public static String desc_cas_055 = "DESC_CAS_055";
	public static String dese_cas_055 = "DESC_EUS_055";
	public static String usua_055 = "USUA_055";
	
	public static String idtp_doc_069 = "IDTP_DOC_069";
	public static String desc_cas_069 = "DESC_CAS_069";
	public static String desc_eus_069 = "DESC_EUS_069";
	public static String desc_cas_052 = "DESC_CAS_052";
	public static String desc_eus_052 = "DESC_EUS_052";
	public static String desc_cas_012 = "DESC_CAS_012";
	public static String desc_eus_012 = "DESC_EUS_012";
	public static String tipos_doc_table = "W83B69T00";
	public static String c_tram_069 = "C_TRAM_069";
	public static String c_fase_069 = "C_FASE_069";
	
	public static String cod_fase = "COD_FASE";
	public static String desc_fase = "DESC_FASE";
	public static String dese_fase = "DESE_FASE";
	public static String desc_tramite = "DESC_TRAMITE";
	public static String dese_tramite = "DESE_TRAMITE";
	public static String usu_alta = "USU_ALTA";
	public static String fecha_alta = "FECHA_ALTA";
	public static String usu_mod = "USU_MOD";
	public static String fecha_mod = "FECHA_MOD";
	public static String fecha_reg_salida = "FECHA_REG_SALIDA";
	public static String num_reg_salid = "NUM_REG_SALID";
	public static String ano_preaviso = "ANO_PREAVISO";
	public static String fecha_alta_tramite = "FECHA_ALTA_TRAMITE";
	
}
